Student 
EntityType  Independent 
Logical Entity Name  Student 
Default Table Name  syStudent 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

Student Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
SSN    VARCHAR(30)  YES 
 
TitleId    INTEGER  NO 
 
LastName    VARCHAR(25)  NO 
 
FirstName    VARCHAR(25)  NO 
 
NickName    VARCHAR(14)  NO 
 
MaidenName    VARCHAR(19)  NO 
 
StreetAddress    VARCHAR(255)  NO 
 
StreetAddress2    CHAR(1)  YES 
 
City    VARCHAR(25)  NO 
 
State    CHAR(2)  NO 
 
PostalCode    CHAR(10)  NO 
 
IsBadAddress    BIT  NO 
 
Id(FK)    INTEGER  YES 
 
Id(FK)    INTEGER  YES 
 
PhoneNumber    CHAR(16)  NO 
 
WorkPhoneNumber    CHAR(16)  NO 
 
WorkPhoneNumberExtension    VARCHAR(10)  NO 
 
IsBadPhone    BIT  NO 
 
LeadDate    DATETIME  YES 
 
LeadTypeId(FK)    INTEGER  YES 
 
GenderId    INTEGER  NO 
 
AmRaceID    INTEGER  NO 
 
NationalityId    INTEGER  NO 
 
MaritalStatusId    INTEGER  NO 
 
DriverLicenseState    CHAR(2)  NO 
 
DriverLicenseNumber    CHAR(20)  NO 
 
DateOfBirth    DATETIME  YES 
 
AlienNumber    CHAR(9)  YES 
 
AgencyId    INTEGER  NO 
 
CitizenId    INTEGER  NO 
 
EmailAddress    VARCHAR(50)  NO 
 
SchoolStatusId(FK)    INTEGER  YES 
 
AssignedAdmissionsRepId    INTEGER  NO 
 
LeadSourceId(FK)    INTEGER  NO 
 
CampusId(FK)    INTEGER  YES 
 
ProgramGroupId    INTEGER  NO 
 
ProgramId(FK)    INTEGER  YES 
 
ShiftId(FK)    INTEGER  YES 
 
StartDate    DATETIME  YES 
 
PreviousEducationId(FK)    INTEGER  YES 
 
HighSchoolId    INTEGER  NO 
 
CollegeId(FK)    INTEGER  YES 
 
HsGradDate    DATETIME  YES 
 
ARBalance    MONEY(19, 4)  NO 
 
ArNextTransactionNumber    SMALLINT  NO 
 
ArAccountStatus    CHAR(2)  NO 
 
LastStatementDate    DATETIME  YES 
 
LastStatementBeginDate    DATETIME  YES 
 
LastStatementCloseDate    DATETIME  YES 
 
StatementComment    VARCHAR(200)  NO 
 
DefaultAddressCode    CHAR(1)  YES 
 
DefaultStudentAddressId    INTEGER  YES 
 
StudentNumber    CHAR(10)  YES 
 
PIN    NUMERIC(4, 0)  YES 
 
Note    TEXT  NO 
 
ExtraCurricularActivityId    INTEGER  YES 
 
IsActive    BIT  NO 
 
DataBlockIndicator    BIT  NO 
 
ModFlag    CHAR(1)  NO 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentId(PK)    INTEGER  NO 
 
Disabled    CHAR(1)  NO 
 
Veteran    CHAR(1)  NO 
 
OriginalAssignedAdmissionsRepId    INTEGER  YES 
 
CumulativeGpa    NUMERIC(11, 6)  YES 
 
CumulativeGpaPoints    MONEY(19, 4)  YES 
 
CurrentLDA    DATETIME  YES 
 
GPACredits    MONEY(19, 4)  YES 
 
OriginalStartDate    DATETIME  YES 
 
OriginalExpectedStartDate    DATETIME  YES 
 
OtherPhoneNumber    CHAR(16)  YES 
 
OtherEmailAddress    VARCHAR(50)  YES 
 
LastActivityDate    DATETIME  YES 
 
LastInterestDate    DATETIME  YES 
 
DefaultMasterStudentAddressId(FK)    INTEGER  YES 
 
Suffix    CHAR(3)  YES 
 
MiddleName    VARCHAR(100)  YES 
 
NIStudent    BIT  NO 
 
StudentIdentifier    VARCHAR(44)  YES 
 
PreviousEducationGpa    NUMERIC(11, 6)  YES 
 
HSGraduated    BIT  NO 
 
HSGraduationSession    VARCHAR(10)  YES 
 
HSDateEnrolled    DATETIME  YES 
 
HSLastDateAttended    DATETIME  YES 
 
HSStudRank    INTEGER  YES 
 
HSSchoolSize    INTEGER  YES 
 
HSTranscriptType    TINYINT  YES 
 
HSStudLevel    TINYINT  YES 
 
HSGradYear    VARCHAR(4)  YES 
 
LastNameFirstFour    VARCHAR(4)  YES 
 
PostalCodeFirstThree    VARCHAR(3)  YES 
 
DBIModifiedDate    DATETIME  YES 
 
BestTimeToContact    VARCHAR(10)  YES 
 
RawLastName    VARCHAR(25)  YES 
 
RawFirstName    VARCHAR(25)  YES 
 
RawPhoneNumber    VARCHAR(16)  YES 
 
ACGEligReasonCode    CHAR(2)  YES 
 
FARigorousHighSchoolProgramCodeID(FK)    INTEGER  YES 
 
SmsServiceProviderId(FK)    INTEGER  YES 
 
SubscribeToSMS    BIT  NO 
 
MobilePhoneNumber    VARCHAR(16)  YES 
 
SourceSystem    CHAR(1)  NO 
 
HispanicLatino    CHAR(1)  YES 
 
IsExcludedCrmIntegration    BIT  NO 
 
IsDdVeteran    BIT  NO 
 
HSAcademicGPA    NUMERIC(11, 6)  YES 
 
SuffixId(FK)    INTEGER  YES 
 
AthleticIdentifier    VARCHAR(20)  YES 
 
faGradPlusCounselingDate    DATETIME  YES 
 
IsInDistrict    BIT  NO 
 
IsEftDefaultForStipends    BIT  NO 
 
MI    VARCHAR(1)  NO 
 
PersonId(FK)    INTEGER  YES 
 
LeadSourceId(FK)    INTEGER  YES 
 
EmployerId(FK)    INTEGER  YES 
 
EmploymentStatusId(FK)    INTEGER  YES 
 
AdmissionsRepId(FK)    INTEGER  YES 
 
Id(FK)    INTEGER  YES 
 

Student Keys 
Key Name  Key Type  Keys 
syStudent_SSN_N_N_IDX  Inversion Entry  SSN 
syStudent_SyStudentId_Email_U_N_IDX  Alternate Key  StudentId, EmailAddress 
Nk_SyStudent_SyPersonId  Inversion Entry  PersonId 
syStudent_SyStudentID_U_C_IDX  PrimaryKey  StudentId 
SyStudent_MaidenName_FirstName_SyStudentID_U_N_IDX  Alternate Key  MaidenName, FirstName, StudentId 
syStudent_StuNum_N_N_IDX  Inversion Entry  StudentNumber 
syStudent_FirstName_N_N_IDX  Inversion Entry  FirstName 
Nk_SyStudentAmSuffixID  Inversion Entry  SuffixId 
syStudent_AmRepID_N_N_IDX  Inversion Entry  AssignedAdmissionsRepId 
SyStudent_StudentIdentifier_N_N_IDX  Inversion Entry  StudentIdentifier 
SyStudent_CMSMSServiceProviderID_N_N_IDX  Inversion Entry  SmsServiceProviderId 
SyStudent_MaidenName_NickName_SyStudentID_U_N_IDX  Alternate Key  MaidenName, NickName, StudentId 
SyStudent_OtherEmail_N_N_IDX  Inversion Entry  OtherEmailAddress 
SyStudent_DOB_LastName_Phone_N_N_IDX  Inversion Entry  DateOfBirth, LastName, PhoneNumber 
SyStudent_LastName_NickName_SyStudentID_U_N_IDX  Alternate Key  LastName, NickName, StudentId 
SyStudent_WorkPhone_SyCampusID_SyStudentID_U_N_IDX  Alternate Key  WorkPhoneNumber, StudentId 
SyStudent_Email_SyCampusID_SyStudentID_U_N_IDX  Alternate Key  EmailAddress, StudentId 
SyStudent_Phone_SyCampusID_SyStudentID_U_N_IDX  Alternate Key  PhoneNumber, StudentId 
SyStudent_SySchoolStatusID_Lastname_Firstname_SSN_Phone_SyStudentID_SyCampusId_U_N_IDX  Alternate Key  LastName, FirstName, SSN, PhoneNumber, StudentId 
syStudent_LeadDate_SyCampusID_N_N_IDX  Inversion Entry  LeadDate 
SyStudent_LastName_FirstName_SyCampusID_SSN_Phone_SyStudentID_email_N_N_IDX  Inversion Entry  LastName, FirstName, SSN, PhoneNumber, StudentId, EmailAddress 
SyStudent_AmCitizenID_SyCampusID_INCLUDE_N_N_idx  Inversion Entry  CitizenId 

Student Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
AdmissionsRep  Non-Identifying  Zero or One to Zero or More        AdmissionsRepId  NO 
Campus  Non-Identifying  Zero or One to Zero or More        CampusId  NO 
College  Non-Identifying  Zero or One to Zero or More        CollegeId  NO 
Country  Non-Identifying  Zero or One to Zero or More        Id  NO 
County  Non-Identifying  Zero or One to Zero or More        Id  NO 
Employer  Non-Identifying  Zero or One to Zero or More        EmployerId  NO 
EmploymentStatus  Non-Identifying  Zero or One to Zero or More        EmploymentStatusId  NO 
LeadSource  Non-Identifying  One To Zero or More        LeadSourceId  NO 
SmsServiceProvider  Non-Identifying  Zero or One to Zero or More        SmsServiceProviderId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        DefaultMasterStudentAddressId  NO 
RigorousHighSchoolProgramCode  Non-Identifying  Zero or One to Zero or More        FARigorousHighSchoolProgramCodeID  NO 
Suffix  Non-Identifying  Zero or One to Zero or More        SuffixId  NO 
Person  Non-Identifying  Zero or One to Zero or More        PersonId  NO 
LeadSource  Non-Identifying  Zero or One to Zero or More        LeadSourceId  NO 
LeadType  Non-Identifying  Zero or One to Zero or More        LeadTypeId  NO 
Person  Non-Identifying  Zero or One to Zero or More        PersonId  NO 
PreviousEducation  Non-Identifying  Zero or One to Zero or More        PreviousEducationId  NO 
Program  Non-Identifying  Zero or One to Zero or More        ProgramId  NO 
SchoolStatus  Non-Identifying  Zero or One to Zero or More        SchoolStatusId  NO 
Shift  Non-Identifying  Zero or One to Zero or More        ShiftId  NO 
Title  Non-Identifying  Zero or One to Zero or More        Id  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
StudentCourseDataChange  Non-Identifying  One To Zero or More          NO 
AdAttend_Proxy  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More          NO 
StudentCourseStatusChange  Non-Identifying  One To Zero or More          NO 
AdEnrollSchedStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentTermSummaryRebuildLog  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentTermSummary  Non-Identifying  One To Zero or More          NO 
AdEnrollTermRelationshipException  Non-Identifying  One To Zero or More          NO 
GainfulEmploymentReportStudent  Non-Identifying  One To Zero or More          NO 
StudentGpaIncludedCourse  Non-Identifying  One To Zero or More          NO 
StudentGpa  Non-Identifying  One To Zero or More          NO 
RegistrationRule  Non-Identifying  One To Zero or More          NO 
AdStudentTermSequenceHeader  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodTransfer  Non-Identifying  One To Zero or More          NO 
AmApplicant  Identifying  One To Zero or More          NO 
StudentTransferCredit  Non-Identifying  One To Zero or More          NO 
AmCollegeTransferAdvance  Non-Identifying  One To Zero or More          NO 
Document  Non-Identifying  One To Zero or More          NO 
StudentCourseDocumentPermit  Non-Identifying  One To Zero or More          NO 
FerpaStudentDirectoryField  Non-Identifying  One To Zero or More          NO 
FerpaStudentRelationshipInfoShareDetail  Non-Identifying  One To Zero or More          NO 
IncidentStudent  Non-Identifying  One To Zero or More          NO 
StudentContactPreference  Non-Identifying  One To Zero or More          NO 
CmResidencyStudentRelation  Non-Identifying  One To Zero or More          NO 
AwardLetterPrintQueue  Non-Identifying  One To Zero or More          NO 
FaCampusVantageWorkStudyPayroll  Non-Identifying  One To Zero or More          NO 
FaCorrections00  Non-Identifying  One To Zero or More          NO 
StudentAwardPellEstimate  Non-Identifying  One To Zero or More          NO 
StudentAwardEstimate  Non-Identifying  One To Zero or More          NO 
StudentAcademicYearEstimate  Identifying  One To Zero or More          NO 
FaFAFSA04  Non-Identifying  One To Zero or More          NO 
FaFAFSA08  Non-Identifying  One To Zero or More          NO 
FaFAFSA09  Non-Identifying  One To Zero or More          NO 
FaFAFSA10  Non-Identifying  One To Zero or More          NO 
FaFAFSA11  Non-Identifying  One To Zero or More          NO 
FaFAFSA12  Non-Identifying  One To Zero or More          NO 
FaFafsa  Non-Identifying  One To Zero or More          NO 
StateGrantHopeEvaluationResult  Non-Identifying  One To Zero or More          NO 
FaISIRcCode  Identifying  One To Zero or More          NO 
IsirCorrection  Non-Identifying  One To Zero or More          NO 
FAISIRMatch  Non-Identifying  One To Zero or More          NO 
IsirMatch  Non-Identifying  One To Zero or More          NO 
StudentAwardLoanApplication  Non-Identifying  One To Zero or More          NO 
FaMultiDisbException  Non-Identifying  One To Zero or More          NO 
StudentNsldsSummary  Non-Identifying  One To Zero or More          NO 
FaShoppingSheet  Non-Identifying  One To Zero or More          NO 
StudentAward  Non-Identifying  One To Zero or More          NO 
FaStudentAidCashPlanHistory  Non-Identifying  One To Zero or More          NO 
FaStudentAutoAwardLog  Non-Identifying  One To Zero or More          NO 
FaStudentDocs  Non-Identifying  One To Zero or More          NO 
FafsaSummary  Non-Identifying  One To Zero or More          NO 
StudentAwardNonTitleIvRule  Non-Identifying  One To Zero or More          NO 
FaStudentMaster  Non-Identifying  One To Zero or More          NO 
StudentAwardPell  Non-Identifying  One To Zero or More          NO 
FaTsmMain  Non-Identifying  One To Zero or More          NO 
IsirVerificationResult  Non-Identifying  One To Zero or More          NO 
HsBuildingRoomsStudents  Non-Identifying  One To Zero or More          NO 
HsRoomMateMatchStudent  Non-Identifying  One To Zero or More          NO 
HousingApplicationStudent  Non-Identifying  One To Zero or More          NO 
HsStudentApplicationAnswers  Non-Identifying  One To Zero or More          NO 
HousingLease  Non-Identifying  One To Zero or More          NO 
HsStudentResponseComments  Non-Identifying  One To Zero or More          NO 
PlStudentApplyHist  Non-Identifying  One To Zero or More          NO 
StudentPlacementSummaryInSchoolDetail  Non-Identifying  One To Zero or More          NO 
StudentPlacementSearchAgent  Non-Identifying  One To Zero or More          NO 
Sa1098TBatchDetail  Identifying  One To Zero or More          NO 
SaBillingStatementBatchDetailCharges  Non-Identifying  One To Zero or More          NO 
SaBillingStatementBatchDetailFA  Non-Identifying  One To Zero or More          NO 
SaBillingStatementBatchDetailPayments  Non-Identifying  One To Zero or More          NO 
StudentBillingStatementBatch  Non-Identifying  One To Zero or More          NO 
StudentBillingStatementBatchDetail  Non-Identifying  One To Zero or More          NO 
SaBillingStatementBatchSubsidiaryDetail  Non-Identifying  One To Zero or More          NO 
CollectionAccount  Non-Identifying  One To Zero or More          NO 
DisbursementReceiptNotification  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionAppliedPayment  Non-Identifying  One To Zero or More          NO 
StudentAccountPendingTransaction  Non-Identifying  One To Zero or More          NO 
StudentStatement  Non-Identifying  One To Zero or More          NO 
StudentBankAccount  Non-Identifying  One To Zero or More          NO 
StudentAthleticDetail  Non-Identifying  One To Zero or More          NO 
StudentDisabilityDetail  Non-Identifying  One To Zero or More          NO 
StudentServiceType  Non-Identifying  One To Zero or More          NO 
StudentVeteranDetail  Non-Identifying  One To Zero or More          NO 
SsStudRoommate  Identifying  One To Zero or More          NO 
SyAudit_AdAttend  Non-Identifying  One To Zero or More          NO 
SyAudit_AdAttendArchive  Non-Identifying  One To Zero or More          NO 
DepositDataChange  Non-Identifying  One To Zero or More          NO 
SyAudit_AmProspectTest  Non-Identifying  One To Zero or More          NO 
DocumentDataChange  Non-Identifying  One To Zero or More          NO 
SyAudit_FaStateEligibility  Non-Identifying  One To Zero or More          NO 
StudentDataChange  Non-Identifying  One To Zero or More          NO 
SyCornerstoneBatchDetail  Non-Identifying  One To Zero or More          NO 
SyGPACalculateQueue  Non-Identifying  One To Zero or More          NO 
SyIndicatorStudentRelation  Non-Identifying  One To Zero or More          NO 
DoNotCallStudentCrossReference  Non-Identifying  One To Zero or More          NO 
FaaProcessSourceRecord  Non-Identifying  One To Zero or More          NO 
SevisFileTransmissionDetail  Non-Identifying  One To Zero or More          NO 
SevisDataChange  Non-Identifying  One To Zero or More          NO 
SevisStudentSiteActivity  Non-Identifying  One To Zero or More          NO 
StudentEthnicity  Non-Identifying  One To Zero or More          NO 
SyStudentExternalDMConfiguration  Non-Identifying  One To Zero or More          NO 
SyStudentExternalDMIdentifierMap  Non-Identifying  One To Zero or More          NO 
SyStudentExternalMap  Non-Identifying  One To Zero or More          NO 
SyStudentExternalMap  Non-Identifying  One To Zero or More          NO 
SevisStudent  Non-Identifying  One To Zero or More          NO 
SevisStudentDependent  Non-Identifying  One To Zero or More          NO 
StudentHighSchoolContact  Non-Identifying  One To Zero or More          NO 
SyStudentResidencyStatus  Non-Identifying  One To Zero or More          NO 
AdmissionsRepLeadReassignment  Non-Identifying  One To Zero or More          NO 
CollectionAccount  Non-Identifying  One To Zero or More          NO 
CollectionAccountDataChange  Non-Identifying  One To Zero or More          NO 
Document  Non-Identifying  One To Zero or More          NO 
DocumentDataChange  Non-Identifying  One To Zero or More          NO 
EntranceTestScore  Non-Identifying  One To Zero or More          NO 
FerpaStudentDirectoryField  Non-Identifying  One To Zero or More          NO 
FerpaStudentRelationshipInfoShareDetail  Non-Identifying  One To Zero or More          NO 
GeneralLedgerReleaseBatchDetail  Non-Identifying  One To Zero or More          NO 
IncidentStudent  Non-Identifying  One To Zero or More          NO 
PaidDisbursement  Non-Identifying  One To Zero or More          NO 
PendingApplicant  Non-Identifying  One To Zero or More          NO 
ProspectInquiry  Non-Identifying  One To Zero or More          NO 
ProspectInquiryLeadSource  Non-Identifying  One To Zero or More          NO 
ProspectInquiryLeadSourceDataChange  Non-Identifying  One To Zero or More          NO 
ProspectInquiryProgram  Non-Identifying  One To Zero or More          NO 
ProspectInquiryStatusSummary  Non-Identifying  One To Zero or More          NO 
ProspectInquiryStatusSummaryByAdmissRep  Non-Identifying  One To Zero or More          NO 
Refund  Non-Identifying  One To Zero or More          NO 
RegistrationRule  Non-Identifying  One To Zero or More          NO 
ScheduledDisbursement  Non-Identifying  One To Zero or More          NO 
SevisDataChange  Non-Identifying  One To Zero or More          NO 
SevisFileTransmissionDetail  Non-Identifying  One To Zero or More          NO 
SevisStudent  Non-Identifying  One To Zero or More          NO 
SevisStudentDependent  Non-Identifying  One To Zero or More          NO 
SevisStudentSiteActivity  Non-Identifying  One To Zero or More          NO 
StipendSummary  Non-Identifying  One To Zero or More          NO 
StudentAccountPendingTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionAdjustment  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionAppliedPayment  Non-Identifying  One To Zero or More          NO 
StudentAdvisorDataChange  Non-Identifying  One To Zero or More          NO 
StudentAgencyBranch  Non-Identifying  One To Zero or More          NO 
StudentAward  Non-Identifying  One To Zero or More          NO 
StudentBankAccount  Non-Identifying  One To Zero or More          NO 
StudentBillingStatementBatch  Non-Identifying  One To Zero or More          NO 
StudentBillingStatementBatchDetail  Non-Identifying  One To Zero or More          NO 
StudentCertification  Non-Identifying  One To Zero or More          NO 
StudentContactPreference  Non-Identifying  One To Zero or More          NO 
StudentCourse  Non-Identifying  One To Zero or More          NO 
StudentCourseDocumentPermit  Non-Identifying  One To Zero or More          NO 
StudentCourseStatusChange  Non-Identifying  One To Zero or More          NO 
StudentCreditCard  Non-Identifying  One To Zero or More          NO 
StudentDegreePathway  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodFee  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentPeriodTransfer  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentTermSummary  Non-Identifying  One To Zero or More          NO 
StudentEnrollmentTermSummaryRebuildLog  Non-Identifying  One To Zero or More          NO 
StudentExtraCurricularActivity  Non-Identifying  One To Zero or More          NO 
StudentGpa  Non-Identifying  One To Zero or More          NO 
StudentGpaIncludedCourse  Non-Identifying  One To Zero or More          NO 
StudentHighSchoolContact  Non-Identifying  One To Zero or More          NO 
StudentPlacementDataChange  Non-Identifying  One To Zero or More          NO 
StudentPlacementDeletedRecord  Non-Identifying  One To Zero or More          NO 
StudentPlacementSearchAgent  Non-Identifying  One To Zero or More          NO 
StudentPlacementSummary  Non-Identifying  One To Zero or More          NO 
StudentPlacementSummaryInSchoolDetail  Non-Identifying  One To Zero or More          NO 
StudentPreviousEducation  Non-Identifying  One To Zero or More          NO 
StudentPreviousEducationDataChange  Non-Identifying  One To Zero or More          NO 
StudentRelationshipAddress  Non-Identifying  One To Zero or More          NO 
StudentRt4Calculation  Non-Identifying  One To Zero or More          NO 
StudentSchoolStatusHistory  Non-Identifying  One To Zero or More          NO 
StudentStatement  Non-Identifying  One To Zero or More          NO 
StudentSubsidiaryStatement  Non-Identifying  One To Zero or More          NO 
StudentTransferCredit  Non-Identifying  One To Zero or More          NO 
Task  Non-Identifying  One To Zero or More          NO 
TaskArchive  Non-Identifying  One To Zero or More          NO 
TaskDocumentAttachment  Non-Identifying  One To Zero or More          NO 
TranscriptRequest  Non-Identifying  One To Zero or More          NO 

Student Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_SyStudent_LastInterestDate_OriginalStartDate  (([LastInterestDate] > [OriginalStartDate] or [LastInterestDate] is null and [OriginalStartDate] is null or [LastInterestDate] is null and [OriginalStartDate] is not null) and ((not([LastInterestDate] is not null and [OriginalStartDate] is null)))) 

Student Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.Student 
NO       
Physical (Microsoft SQL Server)
dbo.syStudent 
NO       

Student Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Addresses_Affiliations 
Logical  Applicant_Enroll 
Logical  CourseRegistration 
Logical  DegreePathway 
Logical  Documents 
Logical  FERPA 
Logical  Grades/Attendance 
Logical  Incidents 
Logical  LedgerCard_Billing 
Logical  PreviousEd_TransferCredits 
Logical  Prospect 
Logical  RefundCalculation 
Logical  Refunds_Stipends 
Logical  Revenue_GL_BankDeposit 
Logical  SEVIS 
Logical  StudentEnrollment 
Logical  StudentJobPlacement 
Logical  StudentPayments_Collections 
Logical  StudentPlacementPreferences 
Logical  SubsidiaryLedger 
Logical  Tasks 
Logical  TestScores 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 
Physical (Microsoft SQL Server)  System 

Student Data Movement Rules 
Name  Type  Rule Text/Value